------
----------------INIT SYSTEM DATA
-------
-----For properties
Insert into OB_PROPERTIES  (PROP_ID, PROP_NAME, PROP_VALUE, PROP_TYPE, CREATED_DATE, CREATED_BY)  Values   (OB_PROPERTIES_SEQ.nextval, 'Send Notice Email Second', '7', 'NOTICE_EMAIL_SECOND_TIMES',sysdate, 'System');
Insert into OB_PROPERTIES  (PROP_ID, PROP_NAME, PROP_VALUE, PROP_TYPE, CREATED_DATE, CREATED_BY)  Values   (OB_PROPERTIES_SEQ.nextval, 'Send Notice Email Third', '7', 'NOTICE_EMAIL_THIRD_TIMES', sysdate, 'System');
Insert into OB_PROPERTIES  (PROP_ID, PROP_NAME, PROP_VALUE, PROP_TYPE, CREATED_DATE, CREATED_BY)  Values   (OB_PROPERTIES_SEQ.nextval, 'Send Notice Email Fourth', '7', 'NOTICE_EMAIL_FOURTH_TIMES', sysdate, 'System');
Insert into OB_PROPERTIES  (PROP_ID, PROP_NAME, PROP_VALUE, PROP_TYPE, CREATED_DATE, CREATED_BY)  Values   (OB_PROPERTIES_SEQ.nextval, 'Shut Down Send Notice Email', '7', 'NOTICE_EMAIL_SHUTDOWN', sysdate, 'System');
Insert into OB_PROPERTIES  (PROP_ID, PROP_NAME, PROP_VALUE, PROP_TYPE, CREATED_DATE, CREATED_BY)  Values   (OB_PROPERTIES_SEQ.nextval, 'Notice Email From', 'gang.li@compuware.com', 'NOTICE_EMAIL_FROM', sysdate, 'System');

-----For role
Insert into OB_ROLES  (ROLE_ID, ROLE_NAME,CREATED_DATE, CREATED_BY)  Values   (OB_USERS_SEQ.nextval, 'Admin', sysdate, 'System');
Insert into OB_ROLES  (ROLE_ID, ROLE_NAME,CREATED_DATE, CREATED_BY)  Values   (OB_USERS_SEQ.nextval, 'Agent', sysdate, 'System');
Insert into OB_ROLES  (ROLE_ID, ROLE_NAME,CREATED_DATE, CREATED_BY)  Values   (OB_USERS_SEQ.nextval, 'Supplier', sysdate, 'System');
COMMIT;
